﻿-- ===============================================================================================
-- Basic Reference: Depto
-- ===============================================================================================

DELETE FROM [esf_sso].[TreeBasicReference] WHERE BasicReferenceID IN (SELECT ID FROM [esf_sso].[BasicReference] WHERE [BasicReferenceTypeID] = 10)
DELETE FROM [esf_sso].[BasicReference] WHERE [BasicReferenceTypeID] = 10;


INSERT INTO [esf_sso].[BasicReference] ([BasicReferenceTypeID],[Code],[Name],[Description],[IsEnabled],[CreationDateTime],UserCreationAlias)
SELECT 10, '23162','CERETÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05361','ITUANGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17524','PALESTINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19455','MIRANDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44279','FONSECA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47318','GUAMAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52254','EL PEÑOL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76520','PALMIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15580','QUÍPAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '99001','PUERTO CARREÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18756','SOLANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73624','ROVIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70678','SAN BENITO ABAD', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13212','CÓRDOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13810','TIQUISIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47720','SANTA BÁRBARA DE PINTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68522','PALMAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05842','URAMITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52480','NARIÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19318','GUAPI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25290','FUSAGASUGÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68686','SAN MIGUEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66440','MARSELLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76246','EL CAIRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05030','AMAGÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15762','SORA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05042','SANTAFÉ DE ANTIOQUIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27361','ISTMINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27450','MEDIO SAN JUAN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44650','SAN JUAN DEL CESAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52287','FUNES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25743','SILVANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73675','SAN ANTONIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25718','SASAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05501','OLAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08606','REPELÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13300','HATILLO DE LOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19075','BALBOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27250','EL LITORAL DEL SAN JUAN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50318','GUAMAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15187','CHIVATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15533','PAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15820','TÓPAGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25871','VILLAGÓMEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41668','SAN AGUSTÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19212','CORINTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47707','SANTA ANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73616','RIOBLANCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08433','MALAMBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52381','LA FLORIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73200','COELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73268','ESPINAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52685','SAN BERNARDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20250','EL PASO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20550','PELAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68217','COROMORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73043','ANZOÁTEGUI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17614','RIOSUCIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68575','PUERTO WILCHES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05034','ANDES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20032','ASTREA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23855','VALENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47541','PEDRAZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68162','CERRITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41524','PALERMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19548','PIENDAMÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19821','TORIBIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25123','CACHIPAY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27810','UNIÓN PANAMERICANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54820','TOLEDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73283','FRESNO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18001','FLORENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73236','DOLORES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54553','PUERTO SANTANDER', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20570','PUEBLO BELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25772','SUESCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05376','LA CEJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15272','FIRAVITOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68425','MACARAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13042','ARENAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23807','TIERRALTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68250','EL PEÑÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73449','MELGAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73547','PIEDRAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68121','CABRERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70400','LA UNIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50400','LEJANÍAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68001','BUCARAMANGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15109','BUENAVISTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15172','CHINAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05411','LIBORINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05890','YOLOMBÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08675','SANTA LUCÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25506','VENECIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25592','QUEBRADANEGRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50568','PUERTO GAITÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15135','CAMPOHERMOSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15776','SUTAMARCHÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05240','EBÉJICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54418','LOURDES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13650','SAN FERNANDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15572','PUERTO BOYACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05665','SAN PEDRO DE URABA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68689','SAN VICENTE DE CHUCURÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05113','BURITICÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20710','SAN ALBERTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52051','ARBOLEDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54001','CÚCUTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19743','SILVIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19785','SUCRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25328','GUAYABAL DE SIQUIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52540','POLICARPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13600','RÍO VIEJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20175','CHIMICHAGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52260','EL TAMBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85010','AGUAZUL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25645','SAN ANTONIO DEL TEQUENDAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05313','GRANADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05585','PUERTO NARE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19532','PATÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76892','YUMBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25175','CHÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25473','MOSQUERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63212','CÓRDOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13440','MARGARITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52573','PUERRES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08770','SUAN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15204','CÓMBITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73152','CASABIANCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54800','TEORAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86865','VALLE DEL GUAMUEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05150','CAROLINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13744','SIMITÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41378','LA ARGENTINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47798','TENERIFE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70215','COROZAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05134','CAMPAMENTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05656','SAN JERÓNIMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41319','GUADALUPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05658','SAN JOSÉ DE LA MONTAÑA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54128','CACHIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76890','YOTOCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18150','CARTAGENA DEL CHAIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63594','QUIMBAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15022','ALMEIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54347','HERRÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13001','CARTAGENA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41799','TELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91536','PUERTO ARICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05129','CALDAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15835','TURMEQUÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '88001','SAN ANDRÉS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52227','CUMBAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73055','ARMERO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05861','VENECIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54720','SARDINATA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66045','APÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05364','JARDÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66318','GUÁTICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25793','TAUSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94885','LA GUADALUPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23189','CIÉNAGA DE ORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70001','SINCELEJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70265','GUARANDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70508','OVEJAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76126','CALIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15097','BOAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50110','BARRANCA DE UPÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '95200','MIRAFLORES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27099','BOJAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13160','CANTAGALLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15238','DUITAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25572','PUERTO SALGAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52885','YACUANQUER', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41885','YAGUARÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54871','VILLA CARO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68377','LA BELLEZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19845','VILLA RICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25486','NEMOCÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47692','SAN SEBASTIÁN DE BUENAVISTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15690','SANTA MARÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '95015','CALAMAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20750','SAN DIEGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73861','VENADILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54245','EL CARMEN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76233','DAGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41244','ELÍAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86757','SAN MIGUEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05250','EL BAGRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73411','LÍBANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76243','EL ÁGUILA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68572','PUENTE NACIONAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52411','LINARES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68324','GUAVATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05467','MONTEBELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05790','TARAZÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05847','URRAO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05887','YARUMAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68266','ENCISO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68152','CARCASÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15757','SOCHA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68132','CALIFORNIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73686','SANTA ISABEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86749','SIBUNDOY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13667','SAN MARTÍN DE LOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68895','ZAPATOCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70110','BUENAVISTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '99524','LA PRIMAVERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25148','CAPARRAPÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63690','SALENTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41396','LA PLATA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05001','MEDELLÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23500','MOÑITOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27491','NÓVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27580','RÍO IRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76130','CANDELARIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05360','ITAGUI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25398','LA PEÑA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73148','CARMEN DE APICALÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08421','LURUACO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08638','SABANALARGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20443','MANAURE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25491','NOCAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05306','GIRALDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13006','ACHÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68385','LANDÁZURI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76250','EL DOVIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25279','FOMEQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17380','LA DORADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50711','VISTAHERMOSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52022','ALDANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05856','VALPARAÍSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20011','AGUACHICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05893','YONDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15550','PISBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15599','RAMIRIQUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54810','TIBÚ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66001','PEREIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68679','SAN GIL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86001','MOCOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13655','SAN JACINTO DEL CAUCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68705','SANTA BÁRBARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15401','LA VICTORIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68307','GIRÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05649','SAN CARLOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13620','SAN CRISTÓBAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91407','LA PEDRERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15051','ARCABUCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15244','EL COCUY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50001','VILLAVICENCIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52250','EL CHARCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18094','BELÉN DE LOS ANDAQUIES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18256','EL PAUJIL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73349','HONDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91001','LETICIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41206','COLOMBIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27075','BAHÍA SOLANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27245','EL CARMEN DE ATRATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54172','CHINÁCOTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15180','CHISCAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15804','TIBANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13268','EL PEÑÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52621','ROBERTO PAYÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17042','ANSERMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18753','SAN VICENTE DEL CAGUÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54125','CÁCOTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68855','VALLE DE SAN JOSÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05353','HISPANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20310','GONZÁLEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23570','PUEBLO NUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66682','SANTA ROSA DE CABAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76869','VIJES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25335','GUAYABETAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25426','MACHETA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27787','TADÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85430','TRINIDAD', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25035','ANAPOIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23300','COTORRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15407','VILLA DE LEYVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15686','SANTANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47980','ZONA BANANERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94887','PANA PANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25851','ÚTICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73520','PALOCABILDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05145','CARAMANTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20295','GAMARRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25001','AGUA DE DIOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13894','ZAMBRANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81736','SARAVENA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05237','DON MATÍAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05490','NECOCLÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25307','GIRARDOT', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17877','VITERBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50330','MESETAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15500','OICATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50124','CABUYARO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66383','LA CELIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47030','ALGARROBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '99773','CUMARIBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68500','OIBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85325','SAN LUIS DE PALENQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05093','BETULIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15223','CUBARÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15494','NUEVO COLÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23417','LORICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44847','URIBIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25781','SUTATAUSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41660','SALADOBLANCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85263','PORE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27150','CARMEN DEL DARIEN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52786','TAMINANGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54874','VILLA DEL ROSARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76318','GUACARÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85001','YOPAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41013','AGRADO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50150','CASTILLA LA NUEVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73671','SALDAÑA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44110','EL MOLINO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25120','CABRERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97889','YAVARATÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23670','SAN ANDRÉS SOTAVENTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54250','EL TARRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15720','SATIVANORTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25430','MADRID', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68867','VETAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23686','SAN PELAYO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47555','PLATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25489','NIMAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50287','FUENTE DE ORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85230','OROCUÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05051','ARBOLETES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68211','CONTRATACIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05483','NARIÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41551','PITALITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17616','RISARALDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05197','COCORNÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08573','PUERTO COLOMBIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52385','LA LLANADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52687','SAN LORENZO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70221','COVEÑAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41306','GIGANTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19450','MERCADERES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20383','LA GLORIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52354','IMUÉS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15317','GUACAMAYAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66170','DOSQUEBRADAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05055','ARGELIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97666','TARAIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47675','SALAMINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70771','SUCRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52083','BELÉN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52565','PROVIDENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08832','TUBARÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23586','PURÍSIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25758','SOPÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41078','BARAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15293','GACHANTIVÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19622','ROSAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47551','PIVIJAY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70473','MORROA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54743','SILOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13248','EL GUAMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15516','PAIPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63272','FILANDIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15131','CALDAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85225','NUNCHÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76845','ULLOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05172','CHIGORODÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05670','SAN ROQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13647','SAN ESTANISLAO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19130','CAJIBÍO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76109','BUENAVENTURA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15425','MACANAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25839','UBALÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08372','JUAN DE ACOSTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41791','TARQUI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73770','SUÁREZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15632','SABOYÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70702','SAN JUAN DE BETULIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70708','SAN MARCOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76306','GINEBRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68190','CIMITARRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15212','COPER', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '88564','PROVIDENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05021','ALEJANDRÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05667','SAN RAFAEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86760','SANTIAGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25580','PULÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25736','SESQUILÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15087','BELÉN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15514','PÁEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05873','VIGÍA DEL FUERTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23068','AYAPEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52390','LA TOLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15646','SAMACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15774','SUSACÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13052','ARJONA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25181','CHOACHÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05125','CAICEDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17867','VICTORIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27413','LLORÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68861','VÉLEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05631','SABANETA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15104','BOYACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27660','SAN JOSÉ DEL PALMAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54206','CONVENCIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25326','GUATAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25483','NARIÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19698','SANTANDER DE QUILICHAO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20787','TAMALAMEQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23182','CHINÚ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27745','SIPÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41872','VILLAVIEJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73275','FLANDES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15537','PAZ DE RÍO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15638','SÁCHICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25224','CUCUNUBÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41797','TESALIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76616','RIOFRÍO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17486','NEIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25086','BELTRÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73870','VILLAHERMOSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94884','PUERTO COLOMBIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15276','FLORESTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05088','BELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05400','LA UNIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13062','ARROYOHONDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54109','BUCARASICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81065','ARAUQUITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54599','RAGONVALIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08549','PIOJÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17653','SALAMINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73124','CAJAMARCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68397','LA PAZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68615','RIONEGRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05895','ZARAGOZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70717','SAN PEDRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54660','SALAZAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85300','SABANALARGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19473','MORALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05792','TARSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18205','CURILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25151','CAQUEZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25867','VIANÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63470','MONTENEGRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68872','VILLANUEVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13780','TALAIGUA NUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52233','CUMBITARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15248','EL ESPINO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68547','PIEDECUESTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05541','PEÑOL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23001','MONTERÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27006','ACANDÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47258','EL PIÑON', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68169','CHARTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25281','FOSCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85162','MONTERREY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50226','CUMARAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73217','COYAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25513','PACHO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25662','SAN JUAN DE RÍO SECO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25769','SUBACHOQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41676','SANTA MARÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54680','SANTIAGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68344','HATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15522','PANQUEBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15861','VENTAQUEMADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27495','NUQUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76036','ANDALUCÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41518','PAICOL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52694','SAN PEDRO DE CARTAGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25898','ZIPACÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05440','MARINILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41001','NEIVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41770','SUAZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68092','BETULIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68468','MOLAGAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73873','VILLARRICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20228','CURUMANÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63401','LA TEBAIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15232','CHÍQUIZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17662','SAMANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23466','MONTELÍBANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25740','SIBATÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05390','LA PINTADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25878','VIOTÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15759','SOGAMOSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25530','PARATEBUENO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08560','PONEDERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13580','REGIDOR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52585','PUPIALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70230','CHALÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19355','INZÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73024','ALPUJARRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68418','LOS SANTOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05347','HELICONIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68255','EL PLAYÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73226','CUNDAY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73504','ORTEGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05854','VALDIVIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17174','CHINCHINÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50606','RESTREPO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85015','CHAMEZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86219','COLÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05282','FREDONIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68770','SUAITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25785','TABIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15507','OTANCHE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05686','SANTA ROSA DE OSOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47189','CIÉNAGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52399','LA UNIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '99624','SANTA ROSALÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76823','TORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15531','PAUNA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15763','SOTAQUIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54518','PAMPLONA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68432','MÁLAGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23678','SAN CARLOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27077','BAJO BAUDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70204','COLOSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91405','LA CHORRERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05697','EL SANTUARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50245','EL CALVARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54239','DURANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20238','EL COPEY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44430','MAICAO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73347','HERVEO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15215','CORRALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68682','SAN JOAQUÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70523','PALMITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41020','ALGECIRAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73270','FALAN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05647','SAN ANDRÉS DE CUERQUÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15832','TUNUNGUÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19693','SAN SEBASTIÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19807','TIMBÍO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47245','EL BANCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68464','MOGOTES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76364','JAMUNDÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05660','SAN LUIS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76111','GUADALAJARA DE BUGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15403','LA UVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19533','PIAMONTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13188','CICUCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41298','GARZÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15810','TIPACOQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05736','SEGOVIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13873','VILLANUEVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76736','SEVILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86885','VILLAGARZÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47605','REMOLINO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52207','CONSACA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52427','MAGÜI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54344','HACARÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70429','MAJAGUAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25095','BITUIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50350','LA MACARENA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73563','PRADO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '95025','EL RETORNO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54174','CHITAGÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76041','ANSERMANUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81794','TAME', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05318','GUARNE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50325','MAPIRIPÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05040','ANORÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23672','SAN ANTERO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41503','OPORAPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63302','GÉNOVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13549','PINILLOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27050','ATRATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27086','BELÉN DE BAJIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41006','ACEVEDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68245','EL GUACAMAYO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76001','CALI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52224','CUASPUD', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15332','GÜICÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23419','LOS CÓRDOBAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54498','OCAÑA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25317','GUACHETÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54377','LABATECA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13473','MORALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15667','SAN LUIS DE GACENO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08558','POLONUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52612','RICAURTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52683','SANDONÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25817','TOCANCIPÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68533','PÁRAMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47053','ARACATACA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52720','SAPUYES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25260','EL ROSAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52788','TANGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54405','LOS PATIOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41807','TIMANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68368','JESÚS MARÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68524','PALMAS DEL SOCORRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27001','QUIBDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27160','CÉRTEGUI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15740','SIACHOQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50683','SAN JUAN DE ARAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25535','PASCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94001','INÍRIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18785','SOLITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13030','ALTOS DEL ROSARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52352','ILES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97511','PACOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05321','GUATAPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15299','GARAGOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05038','ANGOSTURA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54670','SAN CALIXTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25843','VILLA DE SAN DIEGO DE UBATE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66075','BALBOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18247','EL DONCELLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41801','TERUEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05690','SANTO DOMINGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13074','BARRANCO DE LOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19573','PUERTO TEJADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52258','EL TABLÓN DE GÓMEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52435','MALLAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52693','SAN PABLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68079','BARICHARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25899','ZIPAQUIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68327','GÜEPSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15466','MONGUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05002','ABEJORRAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47703','SAN ZENÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25815','TOCAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50223','CUBARRAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68780','SURATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94343','BARRANCO MINAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68147','CAPITANEJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05004','ABRIAQUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15480','MUZO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15600','RÁQUIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25658','SAN FRANCISCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08137','CAMPO DE LA CRUZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20621','LA PAZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70235','GALERAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15476','MOTAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52323','GUALMATÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23580','PUERTO LIBERTADOR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52418','LOS ANDES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73678','SAN LUIS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17665','SAN JOSÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15090','BERBEO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15185','CHITARAQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52699','SANTACRUZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52490','OLAYA HERRERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05154','CAUCASIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70742','SAN LUIS DE SINCÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73352','ICONONZO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05138','CAÑASGORDAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23079','BUENAVISTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68773','SUCRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05425','MACEO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05652','SAN FRANCISCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17446','MARULANDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25368','JERUSALÉN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15442','MARIPÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15518','PAJARITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15778','SUTATENZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25178','CHIPAQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85315','SÁCAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13654','SAN JACINTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23168','CHIMÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19701','SANTA ROSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41359','ISNOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27615','RIOSUCIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15218','COVARACHÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25183','CHOCONTÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91530','PUERTO ALEGRÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05615','RIONEGRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15176','CHIQUINQUIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41530','PALESTINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52838','TÚQUERRES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08078','BARANOA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68673','SAN BENITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73030','AMBALEMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25596','QUIPILE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76497','OBANDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25154','CARMEN DE CARUPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50251','EL CASTILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73443','MARIQUITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05101','CIUDAD BOLÍVAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27425','MEDIO ATRATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27800','UNGUÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05190','CISNEROS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19300','GUACHENÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50006','ACACÍAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20400','LA JAGUA DE IBIRICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68077','BARBOSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15837','TUTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25372','JUNÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41483','NÁTAGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25168','CHAGUANÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13657','SAN JUAN NEPOMUCENO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05674','SAN VICENTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94886','CACAHUAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15842','UMBITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13836','TURBACO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27372','JURADÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68502','ONZAGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05107','BRICEÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19392','LA SIERRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25324','GUATAQUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41548','PITAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85400','TÁMARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25862','VERGARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52678','SAMANIEGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73001','IBAGUÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63548','PIJAO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91263','EL ENCANTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15001','TUNJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25488','NILO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05234','DABEIBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05837','TURBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17541','PENSILVANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52560','POTOSÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18610','SAN JOSÉ DEL FRAGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68179','CHIPATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47570','PUEBLOVIEJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50313','GRANADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05642','SALGAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19517','PAEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68271','FLORIÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23350','LA APARTADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23675','SAN BERNARDO DEL VIENTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76020','ALCALÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05206','CONCEPCIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50370','URIBE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47745','SITIONUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76377','LA CUMBRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52203','COLÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15664','SAN JOSÉ DE PARE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52506','OSPINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52240','CHACHAGÜÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05543','PEQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54051','ARBOLEDAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68298','GAMBITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91430','LA VICTORIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15377','LABRANZAGRANDE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25436','MANTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54313','GRAMALOTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91669','PUERTO SANTANDER', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25779','SUSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52696','SANTA BÁRBARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25394','LA PALMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25797','TENA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54520','PAMPLONITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68549','PINCHOTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47960','ZAPAYÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25312','GRANADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25885','YACOPÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50577','PUERTO LLERAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05576','PUEBLORRICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27025','ALTO BAUDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47460','NUEVA GRANADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66594','QUINCHÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76622','ROLDANILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05368','JERICÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15753','SOATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25805','TIBACUY', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25873','VILLAPINZÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05591','PUERTO TRIUNFO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05604','REMEDIOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52405','LEIVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73067','ATACO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86573','LEGUÍZAMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05209','CONCORDIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23464','MOMIL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66400','LA VIRGINIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68322','GUAPOTÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15224','CUCAITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15469','MONIQUIRÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15660','SAN EDUARDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25245','EL COLEGIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25524','PANDI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13688','SANTA ROSA DEL SUR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19824','TOTORÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25269','FACATATIVÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08634','SABANAGRANDE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05044','ANZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18410','LA MONTAÑITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25295','GACHANCIPÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15162','CERINZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15367','JENESANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19513','PADILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81001','ARAUCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25377','LA CALERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68444','MATANZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20013','AGUSTÍN CODAZZI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05579','PUERTO BERRÍO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17433','MANZANARES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76403','LA VICTORIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91460','MIRITI - PARANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05495','NECHÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19256','EL TAMBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25288','FÚQUENE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05212','COPACABANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25286','FUNZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19760','SOTARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47001','SANTA MARTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44378','HATONUEVO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05264','ENTRERRIOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15511','PACHAVITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05664','SAN PEDRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08001','BARRANQUILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76147','CARTAGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97001','MITÚ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44035','ALBANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19142','CALOTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54480','MUTISCUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13244','EL CARMEN DE BOLÍVAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19001','POPAYÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68235','EL CARMEN DE CHUCURÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76563','PRADERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54261','EL ZULIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20614','RÍO DE ORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23555','PLANETA RICA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47161','CERRO SAN ANTONIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63130','CALARCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66088','BELÉN DE UMBRÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25612','RICAURTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05120','CÁCERES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54223','CUCUTILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76275','FLORIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15806','TIBASOSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68684','SAN JOSÉ DE MIRANDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94663','MAPIRIPANA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15114','BUSBANZÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50450','PUERTO CONCORDIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08520','PALMAR DE VARELA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44090','DIBULLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70124','CAIMITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15790','TASCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25053','ARBELÁEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20178','CHIRIGUANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23574','PUERTO ESCONDIDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68498','OCAMONTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05679','SANTA BÁRBARA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13673','SANTA CATALINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76113','BUGALAGRANDE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86568','PUERTO ASÍS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05091','BETANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18479','MORELIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25823','TOPAIPÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05756','SONSON', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05380','LA ESTRELLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73483','NATAGAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13760','SOPLAVIENTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08141','CANDELARIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19418','LÓPEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63190','CIRCASIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73854','VALLE DE SAN JUAN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52256','EL ROSARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68209','CONFINES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86320','ORITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52356','IPIALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15464','MONGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15879','VIRACACHÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44420','LA JAGUA DEL PILAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44560','MANAURE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47545','PIJIÑO DEL CARMEN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17873','VILLAMARÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76834','TULUÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15693','SANTA ROSA DE VITERBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13222','CLEMENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13838','TURBANÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20001','VALLEDUPAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20517','PAILITAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05607','RETIRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68573','PUERTO PARRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25754','SOACHA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15325','GUAYATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25214','COTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68160','CEPITÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68820','TONA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20770','SAN MARTÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70820','SANTIAGO DE TOLÚ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25200','COGUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15189','CIÉNEGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52036','ANCUYÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54385','LA ESPERANZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73461','MURILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25126','CAJICÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25845','UNE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73622','RONCESVALLES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05059','ARMENIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05475','MURINDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13140','CALAMAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47288','FUNDACIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05036','ANGELÓPOLIS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15183','CHITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68176','CHIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15092','BETÉITIVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15798','TENZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15822','TOTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68207','CONCEPCIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52079','BARBACOAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54673','SAN CAYETANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68081','BARRANCABERMEJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91540','PUERTO NARIÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '95001','SAN JOSÉ DEL GUAVIARE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17272','FILADELFIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19050','ARGELIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68755','SOCORRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08849','USIACURÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25518','PAIME', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50689','SAN MARTÍN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85279','RECETOR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19290','FLORENCIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44855','URUMITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15839','TUTAZÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17444','MARQUETALIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70233','EL ROBLE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25320','GUADUAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41016','AIPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41357','IQUIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15676','SAN MIGUEL DE SEMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19780','SUÁREZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05819','TOLEDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19022','ALMAGUER', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27135','EL CANTÓN DEL SAN PABLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13468','MOMPÓS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17013','AGUADAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15491','NOBSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25653','SAN CAYETANO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68370','JORDÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05628','SABANALARGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13442','MARÍA LA BAJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13458','MONTECRISTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17495','NORCASIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68229','CURITÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05079','BARBOSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17442','MARMATO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20045','BECERRIL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52019','ALBÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70670','SAMPUÉS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76828','TRUJILLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68276','FLORIDABLANCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15764','SORACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13433','MAHATES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76400','LA UNIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68318','GUACA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85250','PAZ DE ARIPORO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94888','MORICHAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85139','MANÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15681','SAN PABLO DE BORBUR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47170','CHIBOLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54003','ABREGO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05148','EL CARMEN DE VIBORAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68745','SIMACOTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25258','EL PEÑÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25594','QUETAME', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17777','SUPÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25649','SAN BERNARDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15106','BRICEÑO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25407','LENGUAZAQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05086','BELMIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52215','CÓRDOBA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25040','ANOLAIMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44874','VILLANUEVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13670','SAN PABLO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19110','BUENOS AIRES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76606','RESTREPO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17001','MANIZALES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25322','GUASCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25841','UBAQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44078','BARRANCAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66687','SANTUARIO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68655','SABANA DE TORRES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85125','HATO COROZAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05142','CARACOLÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05315','GUADALUPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41615','RIVERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05031','AMALFI', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '11001','BOGOTÁ, D.C.', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17050','ARANZAZU', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15226','CUÍTIVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41349','HOBO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68013','AGUADA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97161','CARURU', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27205','CONDOTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50590','PUERTO RICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05761','SOPETRÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76863','VERSALLES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25807','TIBIRITA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44001','RIOHACHA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '91798','TARAPACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15236','CHIVOR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25386','LA MESA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81220','CRAVO NORTE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05284','FRONTINO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86569','PUERTO CAICEDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '97777','PAPUNAUA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50680','SAN CARLOS DE GUAROA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15542','PESCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25293','GACHALA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15696','SANTA SOFÍA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47660','SABANAS DE SAN ANGEL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68101','BOLÍVAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19585','PURACÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25438','MEDINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76122','CAICEDONIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15816','TOGÜÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23090','CANALETE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73168','CHAPARRAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76895','ZARZAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25777','SUPATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68167','CHARALÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15362','IZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85440','VILLANUEVA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25875','VILLETA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15368','JERICÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15761','SOMONDOCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68264','ENCINO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05885','YALÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86571','PUERTO GUZMÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70713','SAN ONOFRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15755','SOCOTÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68669','SAN ANDRÉS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25299','GAMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68296','GALÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27430','MEDIO BAUDÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52520','FRANCISCO PIZARRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76248','EL CERRITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18029','ALBANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41132','CAMPOALEGRE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52320','GUAITARILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '44098','DISTRACCIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52317','GUACHUCAL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54099','BOCHALEMA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73585','PURIFICACIÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18460','MILÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68720','SANTA HELENA DEL OPÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05480','MUTATÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08296','GALAPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27600','RÍO QUITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52378','LA CRUZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70823','TOLÚ VIEJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25339','GUTIÉRREZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25297','GACHETÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25799','TENJO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08685','SANTO TOMÁS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63001','ARMENIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73555','PLANADAS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15380','LA CAPILLA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25019','ALBÁN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15296','GAMEZA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81300','FORTUL', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05045','APARTADÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '27073','BAGADÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25402','LA VEGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68320','GUADALUPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '81591','PUERTO RONDÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05147','CAREPA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19100','BOLÍVAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76670','SAN PEDRO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08436','MANATÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15723','SATIVASUR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '86755','SAN FRANCISCO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05310','GÓMEZ PLATA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68020','ALBANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05308','GIRARDOTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68406','LEBRÍJA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15047','AQUITANIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73408','LÉRIDA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15897','ZETAQUIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05858','VEGACHÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13430','MAGANGUÉ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73319','GUAMO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05809','TITIRIBÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52001','PASTO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52835','SAN ANDRES DE TUMACO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '70418','LOS PALMITOS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05789','TÁMESIS', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47205','CONCORDIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76100','BOLÍVAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15322','GUATEQUE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19137','CALDONO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '68051','ARATOCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05266','ENVIGADO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85136','LA SALINA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66572','PUEBLO RICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17388','LA MERCED', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25745','SIMIJACA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '05659','SAN JUAN DE URABÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23660','SAHAGÚN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25599','APULO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '63111','BUENAVISTA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15814','TOCA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50270','EL DORADO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '85410','TAURAMENA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '20060','BOSCONIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50573','PUERTO LÓPEZ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15673','SAN MATEO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15808','TINJACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52210','CONTADERO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15455','MIRAFLORES', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '25099','BOJACÁ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19364','JAMBALÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47058','ARIGUANÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '47268','EL RETÉN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '76054','ARGELIA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '50686','SAN JUANITO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '94883','SAN FELIPE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '15621','RONDÓN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52110','BUESACO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '52473','MOSQUERA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '54398','LA PLAYA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17088','BELALCÁZAR', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '08758','SOLEDAD', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18592','PUERTO RICO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '17513','PÁCORA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19397','LA VEGA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '66456','MISTRATÓ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '41026','ALTAMIRA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '73026','ALVARADO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '19809','TIMBIQUÍ', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13683','SANTA ROSA', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '18860','VALPARAÍSO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '00000','NO DEFINIDO', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23682','SAN JOSE DE URE', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '23815','TUCHIN', NULL, 1, GETDATE (), 'root' UNION ALL 
SELECT 10, '13490','NOROSI', NULL, 1, GETDATE (), 'root' 


-- ============================================================
-- Vinculo Departamento - Ciudad/Municipio
-- ============================================================

/*INSERT INTO [esf_sso].TreeBasicReference (ParentBasicReferenceID, BasicReferenceID)
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23162') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05361') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17524') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19455') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44279') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52254') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76520') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15580') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '99'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '99001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18756') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73624') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70678') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13212') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13810') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47720') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68522') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05842') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52480') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25290') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66440') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76246') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05030') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15762') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05042') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27361') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27450') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44650') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52287') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25743') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73675') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25718') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05501') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08606') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13300') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19075') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15187') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15533') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15820') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25871') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41668') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19212') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47707') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73616') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08433') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52381') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73200') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73268') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52685') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20550') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68217') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73043') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17614') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68575') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05034') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20032') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23855') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47541') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68162') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41524') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19548') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19821') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25123') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27810') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54820') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73283') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73236') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54553') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20570') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25772') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05376') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15272') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68425') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13042') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23807') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73449') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73547') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68121') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15109') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15172') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05411') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05890') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08675') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25506') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25592') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50568') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15135') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15776') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05240') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54418') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13650') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15572') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05665') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68689') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05113') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20710') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52051') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19743') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19785') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25328') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52540') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13600') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20175') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52260') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85010') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25645') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05313') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05585') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19532') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76892') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25175') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25473') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63212') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13440') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08770') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15204') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73152') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54800') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86865') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05150') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13744') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41378') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47798') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70215') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05134') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05656') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41319') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05658') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54128') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76890') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18150') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63594') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15022') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54347') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41799') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91536') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05129') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15835') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '88'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '88001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52227') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73055') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05861') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54720') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66045') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05364') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25793') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23189') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70265') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70508') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76126') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15097') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50110') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '95'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '95200') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27099') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13160') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15238') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25572') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54871') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68377') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19845') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25486') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47692') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15690') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '95'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '95015') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20750') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73861') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76233') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41244') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86757') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73411') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76243') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68572') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52411') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68324') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05467') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05790') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05847') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05887') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68266') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68152') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15757') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68132') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86749') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13667') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68895') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70110') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '99'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '99524') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25148') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63690') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41396') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23500') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27491') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27580') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76130') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05360') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25398') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73148') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08421') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08638') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20443') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25491') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05306') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13006') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68385') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25279') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17380') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50711') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52022') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05856') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20011') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05893') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15550') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15599') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54810') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68679') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13655') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68705') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15401') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68307') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05649') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13620') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91407') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15051') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15244') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18094') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18256') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73349') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41206') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27075') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54172') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15180') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15804') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13268') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52621') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17042') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18753') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54125') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68855') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05353') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20310') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23570') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66682') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76869') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25335') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25426') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27787') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25035') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23300') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15407') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47980') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94887') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25851') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73520') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05145') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20295') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13894') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81736') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05237') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05490') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25307') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17877') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50330') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15500') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50124') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66383') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47030') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '99'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '99773') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68500') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85325') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05093') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15223') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15494') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23417') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44847') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25781') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85263') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27150') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52786') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54874') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41013') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50150') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73671') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44110') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25120') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97889') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15720') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68867') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47555') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25489') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50287') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85230') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05051') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68211') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05483') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41551') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17616') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05197') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52385') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52687') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70221') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41306') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19450') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20383') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52354') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15317') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66170') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05055') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97666') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47675') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70771') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52083') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52565') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08832') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23586') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25758') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41078') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15293') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19622') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47551') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70473') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54743') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13248') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15516') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63272') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15131') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85225') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76845') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05172') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13647') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19130') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76109') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15425') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25839') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08372') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41791') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73770') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15632') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70702') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70708') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76306') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68190') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15212') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '88'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '88564') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05021') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05667') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86760') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25580') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25736') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15087') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15514') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05873') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23068') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52390') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15646') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15774') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13052') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25181') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05125') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17867') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27413') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68861') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05631') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15104') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54206') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25326') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25483') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19698') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20787') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23182') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27745') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41872') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73275') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15537') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15638') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25224') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41797') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76616') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17486') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25086') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73870') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94884') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15276') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05088') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13062') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54109') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81065') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54599') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08549') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17653') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73124') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68397') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68615') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05895') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70717') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85300') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19473') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05792') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18205') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25151') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25867') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63470') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68872') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13780') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52233') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15248') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68547') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05541') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27006') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47258') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68169') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25281') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85162') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50226') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73217') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25513') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25662') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25769') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41676') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54680') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68344') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15522') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15861') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27495') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76036') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41518') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52694') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25898') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05440') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41770') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68092') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68468') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73873') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20228') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63401') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15232') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17662') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23466') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25740') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05390') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25878') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15759') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25530') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08560') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13580') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52585') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70230') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19355') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73024') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68418') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05347') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68255') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73226') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73504') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05854') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17174') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50606') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85015') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86219') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05282') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68770') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25785') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15507') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47189') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52399') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '99'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '99624') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76823') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15531') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15763') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54518') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68432') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23678') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27077') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70204') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91405') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05697') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54239') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20238') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73347') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15215') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68682') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70523') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41020') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73270') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05647') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15832') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19693') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19807') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68464') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76364') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76111') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15403') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19533') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13188') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41298') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15810') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05736') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13873') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76736') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47605') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52207') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52427') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54344') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70429') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25095') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50350') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73563') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '95'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '95025') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54174') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76041') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81794') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50325') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05040') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23672') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41503') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63302') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13549') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27050') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27086') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41006') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52224') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15332') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23419') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54498') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25317') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54377') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13473') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15667') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08558') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52612') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52683') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25817') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68533') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47053') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52720') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25260') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52788') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54405') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41807') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68368') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68524') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27160') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15740') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50683') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25535') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18785') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13030') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52352') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97511') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05321') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15299') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05038') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25843') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66075') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18247') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41801') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05690') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13074') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52258') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52435') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52693') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68079') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25899') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68327') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15466') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05002') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47703') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25815') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50223') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68780') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94343') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68147') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05004') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15480') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15600') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25658') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08137') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20621') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70235') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15476') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52323') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23580') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52418') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73678') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17665') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15090') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15185') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52699') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52490') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05154') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70742') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73352') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05138') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23079') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68773') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05425') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05652') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17446') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25368') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15442') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15518') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15778') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25178') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85315') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13654') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23168') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19701') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41359') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27615') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15218') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25183') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91530') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05615') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15176') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41530') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52838') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08078') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68673') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73030') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25596') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76497') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25154') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50251') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73443') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05101') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27425') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27800') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05190') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19300') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50006') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68077') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15837') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25372') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41483') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25168') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13657') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05674') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94886') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15842') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13836') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27372') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68502') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05107') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19392') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25324') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41548') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25862') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52678') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63548') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91263') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25488') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05234') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05837') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17541') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52560') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18610') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68179') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47570') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50313') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05642') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19517') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68271') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23350') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23675') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76020') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05206') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50370') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47745') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76377') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52203') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15664') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52506') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52240') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05543') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54051') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68298') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15377') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25436') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54313') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91669') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25779') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52696') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25394') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25797') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54520') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68549') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47960') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25312') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50577') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05576') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27025') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47460') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66594') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76622') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05368') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15753') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25805') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25873') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05591') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05604') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52405') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73067') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05209') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23464') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68322') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15224') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15469') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25245') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25524') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13688') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19824') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25269') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08634') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05044') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18410') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25295') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15162') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15367') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19513') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25377') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68444') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20013') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05579') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17433') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76403') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91460') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05495') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19256') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25288') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05212') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25286') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19760') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44378') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05264') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15511') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05664') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76147') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44035') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19142') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54480') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13244') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68235') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76563') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54261') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20614') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23555') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47161') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63130') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66088') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25612') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05120') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54223') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76275') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15806') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68684') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94663') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15114') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50450') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08520') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44090') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70124') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15790') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25053') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20178') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23574') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68498') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05679') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13673') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76113') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86568') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05091') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18479') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25823') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05756') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05380') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73483') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13760') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08141') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19418') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63190') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73854') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52256') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68209') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86320') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52356') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15464') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15879') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44420') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44560') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47545') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17873') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76834') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15693') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13222') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13838') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20517') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05607') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25754') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15325') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25214') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68160') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68820') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20770') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70820') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25200') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15189') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52036') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54385') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73461') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25126') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25845') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73622') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05059') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05475') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13140') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47288') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05036') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15183') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68176') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15092') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15798') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15822') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68207') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52079') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54673') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68081') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91540') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '95'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '95001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17272') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19050') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68755') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08849') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25518') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50689') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85279') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19290') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44855') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15839') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17444') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70233') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25320') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41016') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41357') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15676') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19780') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05819') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19022') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27135') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13468') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17013') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15491') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25653') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68370') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05628') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13442') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13458') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17495') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68229') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05079') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17442') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20045') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52019') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76828') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68276') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15764') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13433') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76400') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68318') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85250') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94888') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85139') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15681') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47170') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54003') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05148') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68745') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25258') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25594') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17777') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25649') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15106') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25407') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05086') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52215') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25040') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44874') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19110') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76606') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25322') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25841') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44078') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66687') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68655') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85125') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05142') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05315') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41615') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05031') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '11'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '11001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17050') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15226') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41349') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68013') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97161') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27205') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50590') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05761') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76863') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25807') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '91'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '91798') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15236') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25386') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81220') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05284') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86569') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '97'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '97777') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50680') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15542') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25293') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15696') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68101') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19585') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25438') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76122') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15816') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23090') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73168') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76895') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25777') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68167') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15362') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85440') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25875') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15368') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15761') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68264') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05885') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86571') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70713') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15755') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68669') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25299') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68296') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52520') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76248') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18029') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41132') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52320') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '44'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '44098') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52317') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54099') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73585') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18460') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68720') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05480') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08296') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27600') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52378') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70823') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25339') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25297') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25799') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08685') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73555') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15380') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25019') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15296') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81300') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05045') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '27'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '27073') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25402') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68320') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '81'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '81591') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05147') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19100') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76670') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08436') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15723') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '86'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '86755') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05310') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68020') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05308') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68406') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15047') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73408') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15897') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05858') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13430') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73319') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05809') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52001') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52835') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '70'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '70418') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05789') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47205') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76100') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15322') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19137') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '68'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '68051') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05266') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85136') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66572') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17388') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25745') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '05'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '05659') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23660') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25599') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '63'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '63111') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15814') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50270') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '85'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '85410') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '20'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '20060') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50573') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15673') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15808') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52210') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15455') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '25'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '25099') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19364') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47058') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '47'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '47268') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '76'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '76054') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '50'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '50686') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '94'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '94883') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '15'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '15621') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52110') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '52'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '52473') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '54'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '54398') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17088') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '08'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '08758') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18592') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '17'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '17513') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19397') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '66'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '66456') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '41'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '41026') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '73'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '73026') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '19'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '19809') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13683') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '18'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '18860') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23682') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '23'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '23815') UNION ALL 
SELECT (SELECT ID FROM esf_sso.VDepto WHERE Code = '13'), (SELECT ID FROM esf_sso.VBasicReference WHERE Code = '13490')*/